Skip to main content

JDBC Driver for Arrow Flight SQL

The JDBC driver for Arrow Flight SQL is an open-source driver that is based on the specifications for the Java Database Connectivity (JDBC) API. However, the Flight JDBC driver uses Apache Arrow, so it is able to move large amounts of data faster, in part because it does not need to serialize and then deserialize data.

This driver solves a problem that is common to many BI tools that access databases through JDBC. These tools bundle a different JDBC driver for each type of database they support, because each of these databases has their own proprietary driver. Bundling multiple JDBC drivers for multiple databases can be difficult to maintain, and responding to support issues for multiple drivers can be costly. Now, provided that a database has an Apache Arrow Flight SQL endpoint enabled, the JDBC driver for Arrow Flight SQL can connect to it.

This driver is licensed under Apache-2.0

Downloading the JDBC Driver for Arrow Flight SQL​

You can download the driver here.

Integrating the JDBC Driver for Arrow Flight SQL​

To integrate the driver into your development environment, add it to your classpath.

Name of the Class​

The name of the class is org.apache.arrow.driver.jdbc.ArrowFlightJdbcDriver.

  • Use this template to create a direct connection to a database that has enabled an Apache Arrow Flight SQL endpoint
    Create direct connection to database
      jdbc:arrow-flight-sql://<hostname>:<port-number>/?useEncryption=false[&<properties>]
    • <properties>: A list of JDBC properties. Values must be URI-encoded
    • useEncryption=false no Encryption